package com.neu.carbon.mes.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.math.BigDecimal;
import java.time.LocalDate;
import java.util.Date;

@Mapper
public interface ScheduledMapper {

    @Select("select serial_no from mes_product_schedule where id =#{scheduleId}")
    String selectNoById(Long scheduleId);


    @Select("select require_quantity from mes_product_schedule where id = #{scheduleId}")
    BigDecimal selectQuantityById(Long scheduleId);

    @Select("select product_date from mes_product_schedule where id = #{scheduleId}")
    Date selectDateById(Long scheduleId);
}
